﻿<%@ Page Title="Estadisticas y Reportes" Language="C#" MasterPageFile="~/Principal.Master" AutoEventWireup="true" CodeBehind="VerEstadisticas.aspx.cs" Inherits="HelpDesk.VerEstadisticas" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
    <style type="text/css">
        .style9
        {
            width: 76px;
        }
        .style10
        {
            width: 73px;
        }
        .style11
        {
            width: 70px;
        }
        .style13
        {
            width: 94px;
        }
        .style14
        {
            width: 99px;
        }
        </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
    <p>
        <br />
    </p>
        <table style="width:111%;">
        <tr>
            <td></td>
            <td></td>
            <td></td>
            <td><asp:CheckBox ID="SelTodo1" runat="server" Text="Seleccionar Todo X" /></td>
            <td>&nbsp;</td>
        </tr>
            <tr>
                <td class="style13" align="right">
                    X:</td>
                <td align="left" class="style9">
                    <asp:ListBox ID="ListBox1" runat="server" AutoPostBack="True" 
                        onselectedindexchanged="ListBox1_SelectedIndexChanged" >
                        <asp:ListItem>Areas</asp:ListItem>
                        <asp:ListItem>Infraestructuras</asp:ListItem>
                        <asp:ListItem>Usuarios</asp:ListItem>
                        <asp:ListItem>Problemas</asp:ListItem>
                    </asp:ListBox>
                </td>
                <td align="right" class="style14">
                    Opción Eje X:</td>
                <td align="center" class="style10">
                    
                    <asp:ListBox ID="ListBox2" runat="server" 
                        DataTextField="DESCRIPCION" DataValueField="DESCRIPCION">
                        <asp:ListItem>Seleccione la Primera Opción</asp:ListItem>
                    </asp:ListBox>
                </td>
                <td align="center" class="style11">
                    &nbsp;</td>
            </tr>
            <tr>
                <td></td>
                <td></td>
                <td></td>
                <td>
                    <asp:CheckBox ID="SelTodo2" runat="server" Text="Seleccionar Todo Y" />
                    </td>
                <td></td>
            </tr>
            <tr>
                <td align="right">Y:</td>
                <td align="left">
                    <asp:ListBox ID="ListBox3" runat="server" 
                        onselectedindexchanged="ListBox3_SelectedIndexChanged" AutoPostBack="True">
                        <asp:ListItem>Areas</asp:ListItem>
                        <asp:ListItem>Infraestructuras</asp:ListItem>
                        <asp:ListItem>Usuarios</asp:ListItem>
                        <asp:ListItem>Problemas</asp:ListItem>
                    </asp:ListBox>
                </td>
                <td align="right">Opción Eje Y:</td>
                <td align="center">
                    <asp:ListBox ID="ListBox4" runat="server" DataTextField="DESCRIPCION" 
                        DataValueField="DESCRIPCION">
                        <asp:ListItem>Seleccione la Primera Opción</asp:ListItem>
                    </asp:ListBox>
                </td>
                <td></td>
            </tr>
            <tr>
                <td></td>
            </tr>
            <tr>
                <td> Fecha Inicio:</td>
                <td>
                    <asp:Calendar ID="Calendar1" runat="server" BackColor="White" 
                        BorderColor="#999999" CellPadding="4" DayNameFormat="Shortest" 
                        Font-Names="Verdana" Font-Size="8pt" ForeColor="Black" Height="180px" 
                        Width="200px">
                        <SelectedDayStyle BackColor="#666666" Font-Bold="True" ForeColor="White" />
                        <SelectorStyle BackColor="#CCCCCC" />
                        <WeekendDayStyle BackColor="#FFFFCC" />
                        <TodayDayStyle BackColor="#CCCCCC" ForeColor="Black" />
                        <OtherMonthDayStyle ForeColor="#808080" />
                        <NextPrevStyle VerticalAlign="Bottom" />
                        <DayHeaderStyle BackColor="#CCCCCC" Font-Bold="True" Font-Size="7pt" />
                        <TitleStyle BackColor="#999999" BorderColor="Black" Font-Bold="True" />
                    </asp:Calendar>
                </td>
                <td> Fecha Fin:</td>
                <td>
                    <asp:Calendar ID="Calendar2" runat="server" BackColor="White" 
                        BorderColor="#999999" CellPadding="4" DayNameFormat="Shortest" 
                        Font-Names="Verdana" Font-Size="8pt" ForeColor="Black" Height="180px" 
                        Width="200px">
                        <SelectedDayStyle BackColor="#666666" Font-Bold="True" ForeColor="White" />
                        <SelectorStyle BackColor="#CCCCCC" />
                        <WeekendDayStyle BackColor="#FFFFCC" />
                        <TodayDayStyle BackColor="#CCCCCC" ForeColor="Black" />
                        <OtherMonthDayStyle ForeColor="#808080" />
                        <NextPrevStyle VerticalAlign="Bottom" />
                        <DayHeaderStyle BackColor="#CCCCCC" Font-Bold="True" Font-Size="7pt" />
                        <TitleStyle BackColor="#999999" BorderColor="Black" Font-Bold="True" />
                    </asp:Calendar>
                </td>
                <td></td>
            </tr>
            </table>
    <div>
        <table style="width: 111%; height: 32px;">
            <tr>
                <td align="center">
                    
                    <asp:Label ID="Label1" runat="server" Text="Seleccione el tipo de gráfica: "></asp:Label>
                    
                    <asp:DropDownList ID="DropDownList1" runat="server">
                        <asp:ListItem>Barras</asp:ListItem>
                        <asp:ListItem>Areas 3D</asp:ListItem>
                        <asp:ListItem>Columnas 3D</asp:ListItem>
                        <asp:ListItem>Cilindros 3D</asp:ListItem>
                        <asp:ListItem>Piramide 3D</asp:ListItem>
                    </asp:DropDownList>
                    
                </td>
            </tr>
            <tr>
                <td align="center">
                    
                    <asp:Label ID="Label_Error" runat="server" ForeColor="Red"></asp:Label>
                    
                </td>
            </tr>
            <tr>
                <td align="center">
                    <asp:Button ID="BtnGraficar" runat="server" onclick="Button1_Click" 
                        Text="Generar Reporte y Grafica" style="height: 26px; " 
                        Width="162px" />
                </td>
            </tr>
        </table>
    </div>
    <div>
        <br />

    </div>
                    <asp:SqlDataSource ID="SqlDSArea" runat="server" 
                        ConnectionString="Provider=OraOLEDB.Oracle.1;Data Source=Gerald-PC;Password=123;User ID=BDDServer" 
                        ProviderName="System.Data.OleDb" 
                        SelectCommand="SELECT id_area, Descripcion FROM Area_Trabajo" ></asp:SqlDataSource>
                    <asp:SqlDataSource ID="SqlDSInfraestructura" runat="server" 
                        ConnectionString="Provider=OraOLEDB.Oracle.1;Data Source=Gerald-PC;Password=123;User ID=BDDServer" 
                        ProviderName="System.Data.OleDb" 
                        SelectCommand="Select Descripcion from Infraestructura" >
                    </asp:SqlDataSource>
                    <asp:SqlDataSource ID="SqlDSUsuario" runat="server" 
                        ConnectionString="Provider=OraOLEDB.Oracle.1;Data Source=Gerald-PC;Password=123;User ID=BDDServer" 
                        ProviderName="System.Data.OleDb" 
                        SelectCommand="SELECT ID_USUARIO descripcion FROM USUARIO" >
                    </asp:SqlDataSource>
                    <asp:SqlDataSource ID="SqlDSProblema" runat="server" 
                        ConnectionString="Provider=OraOLEDB.Oracle.1;Data Source=Gerald-PC;Password=123;User ID=BDDServer" 
                        ProviderName="System.Data.OleDb" 
                        SelectCommand="SELECT DESCRIPCION FROM PROBLEMA " >
                    </asp:SqlDataSource>
                    </asp:Content>
